<ui:composition xmlns="http://www.w3.org/1999/xhtml"
	xmlns:ui="http://java.sun.com/jsf/facelets"
	xmlns:h="http://java.sun.com/jsf/html"
	xmlns:f="http://java.sun.com/jsf/core"
	xmlns:p="http://primefaces.org/ui"
	template="../templates/ui.xhtml">
    
    <ui:define name="head">
        <script type="text/javascript">
            //<![CDATA[
            function restrict(evt) {
                 var charCode = (evt.which) ? evt.which : evt.keyCode
                 if (charCode > 31 && (charCode < 48 || charCode > 57))
                    return false;

                 return true;
              }
              //]]>
        </script>
    </ui:define>
    
	<ui:define name="content">
		
		<h1 class="title ui-widget-header ui-corner-all">Sheet</h1>
		<div class="entry">
            <p>Sheet is an excel-like component to do data manipulation featuring resizable columns, ajax sorting, horizontal/vertical scrolling, frozen headers, 
                keyboard navigation, multi cell selection with meta/shift keys, bulk delete/update and more.</p>
		
			<h:form>
                
                <p:sheet value="#{tableBean.cars}" var="car" scrollHeight="300">
                    <f:facet name="caption">
                        List of Cars
                    </f:facet>
                        
                    <p:column headerText="Model" style="width:125px" sortBy="#{car.model}">
                        <h:inputText value="#{car.model}" />
                    </p:column>

                    <p:column headerText="Year" style="width:125px" sortBy="#{car.year}">
                        <h:inputText value="#{car.year}" onkeypress="return restrict(event)"/>
                    </p:column>
 
                    <p:column headerText="Manufacturer" style="width:125px" sortBy="#{car.manufacturer}">
                        <h:inputText value="#{car.manufacturer}" />
                    </p:column>

                    <p:column headerText="Color" style="width:125px" sortBy="#{car.color}">
                        <h:inputText value="#{car.color}" />
                    </p:column>
                </p:sheet>
                    
			</h:form>
			
			<h3>Source</h3>
			
			<p:tabView>
				<p:tab title="sheet.xhtml">
                    <pre name="code" class="xml">
&lt;h:form&gt;
                
    &lt;p:sheet value="\#{tableBean.cars}" var="car" scrollHeight="300"&gt;
        &lt;f:facet name="caption"&gt;
            List of Cars
        &lt;/f:facet&gt;

        &lt;p:column headerText="Model" style="width:125px" sortBy="\#{car.model}"&gt;
            &lt;h:inputText value="\#{car.model}" /&gt;
        &lt;/p:column&gt;

        &lt;p:column headerText="Year" style="width:125px" sortBy="\#{car.year}"&gt;
            &lt;h:inputText value="\#{car.year}" onkeypress="return restrict(event)"/&gt;
        &lt;/p:column&gt;

        &lt;p:column headerText="Manufacturer" style="width:125px" sortBy="\#{car.manufacturer}"&gt;
            &lt;h:inputText value="\#{car.manufacturer}" /&gt;
        &lt;/p:column&gt;

        &lt;p:column headerText="Color" style="width:125px" sortBy="\#{car.color}"&gt;
            &lt;h:inputText value="\#{car.color}" /&gt;
        &lt;/p:column&gt;
    &lt;/p:sheet&gt;

&lt;/h:form&gt;
                    </pre>
				</p:tab>
				
				<p:tab title="TableBean.java">
                    <pre name="code" class="java">
package org.primefaces.examples.view;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
import java.util.UUID;

import org.primefaces.examples.domain.Car;

public class TableBean implements Serializable {
	
	static {
		colors = new String[10];
		colors[0] = "Black";
		colors[1] = "White";
		colors[2] = "Green";
		colors[3] = "Red";
		colors[4] = "Blue";
		colors[5] = "Orange";
		colors[6] = "Silver";
		colors[7] = "Yellow";
		colors[8] = "Brown";
		colors[9] = "Maroon";

		manufacturers = new String[10];
		manufacturers[0] = "Mercedes";
		manufacturers[1] = "BMW";
		manufacturers[2] = "Volvo";
		manufacturers[3] = "Audi";
		manufacturers[4] = "Renault";
		manufacturers[5] = "Opel";
		manufacturers[6] = "Volkswagen";
		manufacturers[7] = "Chrysler";
		manufacturers[8] = "Ferrari";
		manufacturers[9] = "Ford";
	}

    private final static String[] colors;

	private final static String[] manufacturers;
	
	private List&lt;Car&gt; cars;
	
	public TableBean() {
		cars = new ArrayList&lt;Car&gt;();
		
		populateRandomCars(cars, 50);
	}
	
	private void populateRandomCars(List&lt;Car&gt; list, int size) {
		for(int i = 0 ; i &lt; size ; i++)
			list.add(new Car(getRandomModel(), getRandomYear(), getRandomManufacturer(), getRandomColor()));
	}
	
	public List&lt;Car&gt; getCars() {
		return cars;
	}

	private int getRandomYear() {
		return (int) (Math.random() * 50 + 1960);
	}
	
	private String getRandomColor() {
		return colors[(int) (Math.random() * 10)];
	}
	
	private String getRandomManufacturer() {
		return manufacturers[(int) (Math.random() * 10)];
	}
	
	private String getRandomModel() {
		return UUID.randomUUID().toString().substring(0, 8);
	}
}
                    </pre>
				</p:tab>
			</p:tabView>

		</div>
		
	</ui:define>
</ui:composition>